create database vin_brasil

go

USE [vin_brasil]
GO

/****** Object:  Table [dbo].[Chassi]    Script Date: 07/27/2012 18:21:26 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Chassi](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[dataOcorrencia] [datetime] NULL,
	[bodyNumber] [nvarchar](255) NULL,
	[cModule] [nvarchar](255) NULL,
	[dataImpressao] [datetime] NULL,
	[impresso] [int] NULL,
	[reportDate] [datetime] NULL,
	[SEQ] [bigint] NULL,
	[stationCode] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

USE [vin_brasil]
GO

/****** Object:  Table [dbo].[Parametros]    Script Date: 07/27/2012 18:21:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Parametros](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[dataOcorrencia] [datetime] NULL,
	[alturaCM] [decimal](19, 5) NULL,
	[espacamentoCM] [decimal](19, 5) NULL,
	[larguraCM] [decimal](19, 5) NULL,
	[loteImpressao] [int] NULL,
	[qtdCopias] [int] NULL,
	[nomeFonte] [nvarchar](255) NULL,
	[nomeImpressora] [nvarchar](255) NULL,
	[tipoEtiqueta] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

INSERT INTO [vin_brasil].[dbo].[Parametros]
           ([dataOcorrencia]
           ,[alturaCM]
           ,[espacamentoCM]
           ,[larguraCM]
           ,[loteImpressao]
           ,[qtdCopias]
           ,[nomeFonte]
           ,[nomeImpressora]
           ,[tipoEtiqueta])
     VALUES
           (GETDATE(), 4, 3.5, 11, 10, 3, 'Glaser Becker Stencil', '\Roland GX-24', 'R')
GO



